USE [RD_SalesMart]
GO

/****** Object:  Index [PK_Sales_Star_Facts]    Script Date: 08/13/2010 21:49:18 ******/
ALTER TABLE [dbo].[Sales_Star_Facts] ADD  CONSTRAINT [PK_Sales_Star_Facts] PRIMARY KEY CLUSTERED 
(
	[OrderNumberDocumentCompany] ASC,
	[OrderNumber] ASC,
	[OrderTypeCode] ASC,
	[LineNumber] ASC,
	[OrderSuffix] ASC,
	[TransactionType] ASC,
	[ItemNumber] ASC,
	[BusinessUnitCode] ASC,
	[RequestedDateID] ASC,
	[AddressNumber] ASC,
	[ForecastType] ASC,
	[YearCalendarYear] ASC,
	[SourceID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO


USE [RD_SalesMart]
GO


/****** Object:  Index [IX_AddressNumber_BusinessUnit]    Script Date: 08/13/2010 21:49:06 ******/
CREATE NONCLUSTERED INDEX [IX_AddressNumber_BusinessUnit] ON [dbo].[Sales_Star_Facts] 
(
	[AddressNumber] ASC,
	[BusinessUnitCode] ASC,
	[FactsExtID] ASC,
	[ForecastType] ASC,
	[LineNumber] ASC,
	[ItemNumber] ASC,
	[OrderNumber] ASC,
	[OrderNumberDocumentCompany] ASC,
	[OrderSuffix] ASC,
	[OrderTypeCode] ASC,
	[TransactionType] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO

/****** Object:  Index [IX_Facts_ActualDeliveryDate]    Script Date: 08/13/2010 21:49:06 ******/
CREATE NONCLUSTERED INDEX [IX_Facts_ActualDeliveryDate] ON [dbo].[Sales_Star_Facts] 
(
	[ActualDeliveryDateID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO

/****** Object:  Index [IX_Facts_AddressNumber]    Script Date: 08/13/2010 21:49:06 ******/
CREATE NONCLUSTERED INDEX [IX_Facts_AddressNumber] ON [dbo].[Sales_Star_Facts] 
(
	[AddressNumber] ASC,
	[SourceID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO

/****** Object:  Index [IX_Facts_BusinessUnitID]    Script Date: 08/13/2010 21:49:06 ******/
CREATE NONCLUSTERED INDEX [IX_Facts_BusinessUnitID] ON [dbo].[Sales_Star_Facts] 
(
	[BusinessUnitID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO

/****** Object:  Index [IX_Facts_CancelDateID]    Script Date: 08/13/2010 21:49:06 ******/
CREATE NONCLUSTERED INDEX [IX_Facts_CancelDateID] ON [dbo].[Sales_Star_Facts] 
(
	[CancelDateID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO

/****** Object:  Index [IX_Facts_CompanyID]    Script Date: 08/13/2010 21:49:06 ******/
CREATE NONCLUSTERED INDEX [IX_Facts_CompanyID] ON [dbo].[Sales_Star_Facts] 
(
	[CompanyNumberID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO

/****** Object:  Index [IX_Facts_CostID]    Script Date: 08/13/2010 21:49:06 ******/
CREATE NONCLUSTERED INDEX [IX_Facts_CostID] ON [dbo].[Sales_Star_Facts] 
(
	[CostID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO

/****** Object:  Index [IX_Facts_FactsExtID]    Script Date: 08/13/2010 21:49:06 ******/
CREATE NONCLUSTERED INDEX [IX_Facts_FactsExtID] ON [dbo].[Sales_Star_Facts] 
(
	[FactsExtID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO

/****** Object:  Index [IX_Facts_FactsHdrID]    Script Date: 08/13/2010 21:49:06 ******/
CREATE NONCLUSTERED INDEX [IX_Facts_FactsHdrID] ON [dbo].[Sales_Star_Facts] 
(
	[FactsHdrID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO

/****** Object:  Index [IX_Facts_GLDate]    Script Date: 08/13/2010 21:49:06 ******/
CREATE NONCLUSTERED INDEX [IX_Facts_GLDate] ON [dbo].[Sales_Star_Facts] 
(
	[GLDateID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO

/****** Object:  Index [IX_Facts_InvoiceDate]    Script Date: 08/13/2010 21:49:06 ******/
CREATE NONCLUSTERED INDEX [IX_Facts_InvoiceDate] ON [dbo].[Sales_Star_Facts] 
(
	[InvoiceDateID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO

/****** Object:  Index [IX_Facts_ItemNum_UOMAsInput]    Script Date: 08/13/2010 21:49:06 ******/
CREATE NONCLUSTERED INDEX [IX_Facts_ItemNum_UOMAsInput] ON [dbo].[Sales_Star_Facts] 
(
	[ItemNumber] ASC,
	[UnitOfMeasureAsInput] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO

/****** Object:  Index [IX_Facts_ItemNum_UOMPrimary]    Script Date: 08/13/2010 21:49:06 ******/
CREATE NONCLUSTERED INDEX [IX_Facts_ItemNum_UOMPrimary] ON [dbo].[Sales_Star_Facts] 
(
	[ItemNumber] ASC,
	[UnitOfMeasurePrimary] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO

/****** Object:  Index [IX_Facts_ItemNumberID]    Script Date: 08/13/2010 21:49:06 ******/
CREATE NONCLUSTERED INDEX [IX_Facts_ItemNumberID] ON [dbo].[Sales_Star_Facts] 
(
	[ItemNumberID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO

/****** Object:  Index [IX_Facts_OrderTypeCode]    Script Date: 08/13/2010 21:49:06 ******/
CREATE NONCLUSTERED INDEX [IX_Facts_OrderTypeCode] ON [dbo].[Sales_Star_Facts] 
(
	[OrderTypeCode] ASC,
	[SourceID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO

/****** Object:  Index [IX_Facts_OriginalPromisedDate]    Script Date: 08/13/2010 21:49:06 ******/
CREATE NONCLUSTERED INDEX [IX_Facts_OriginalPromisedDate] ON [dbo].[Sales_Star_Facts] 
(
	[OriginalPromisedDateID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO

/****** Object:  Index [IX_Facts_ParentNumber]    Script Date: 08/13/2010 21:49:06 ******/
CREATE NONCLUSTERED INDEX [IX_Facts_ParentNumber] ON [dbo].[Sales_Star_Facts] 
(
	[ParentNumber] ASC,
	[SourceID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO

/****** Object:  Index [IX_Facts_PriceEffectiveDate]    Script Date: 08/13/2010 21:49:06 ******/
CREATE NONCLUSTERED INDEX [IX_Facts_PriceEffectiveDate] ON [dbo].[Sales_Star_Facts] 
(
	[PriceEffectiveDateID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO

/****** Object:  Index [IX_Facts_PriceID]    Script Date: 08/13/2010 21:49:06 ******/
CREATE NONCLUSTERED INDEX [IX_Facts_PriceID] ON [dbo].[Sales_Star_Facts] 
(
	[PriceID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO

/****** Object:  Index [IX_Facts_PromisedDelDate]    Script Date: 08/13/2010 21:49:06 ******/
CREATE NONCLUSTERED INDEX [IX_Facts_PromisedDelDate] ON [dbo].[Sales_Star_Facts] 
(
	[PromisedDeliveryDateID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO

/****** Object:  Index [IX_Facts_RequestedDate]    Script Date: 08/13/2010 21:49:06 ******/
CREATE NONCLUSTERED INDEX [IX_Facts_RequestedDate] ON [dbo].[Sales_Star_Facts] 
(
	[RequestedDateID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO

/****** Object:  Index [IX_Facts_SalesRepID]    Script Date: 08/13/2010 21:49:06 ******/
CREATE NONCLUSTERED INDEX [IX_Facts_SalesRepID] ON [dbo].[Sales_Star_Facts] 
(
	[SalesRepID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO

/****** Object:  Index [IX_Facts_ShipDate]    Script Date: 08/13/2010 21:49:06 ******/
CREATE NONCLUSTERED INDEX [IX_Facts_ShipDate] ON [dbo].[Sales_Star_Facts] 
(
	[ShipDateID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO

/****** Object:  Index [IX_Facts_ShipToNumber]    Script Date: 08/13/2010 21:49:06 ******/
CREATE NONCLUSTERED INDEX [IX_Facts_ShipToNumber] ON [dbo].[Sales_Star_Facts] 
(
	[ShiptoNumber] ASC,
	[SourceID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO

/****** Object:  Index [IX_Facts_TransactionDate]    Script Date: 08/13/2010 21:49:06 ******/
CREATE NONCLUSTERED INDEX [IX_Facts_TransactionDate] ON [dbo].[Sales_Star_Facts] 
(
	[TransactionDateID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO

/****** Object:  Index [IX_Facts_TranTypeID]    Script Date: 08/13/2010 21:49:06 ******/
CREATE NONCLUSTERED INDEX [IX_Facts_TranTypeID] ON [dbo].[Sales_Star_Facts] 
(
	[TransactionTypeID] ASC,
	[SourceID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO

/****** Object:  Index [IX_Facts_TypeID]    Script Date: 08/13/2010 21:49:06 ******/
CREATE NONCLUSTERED INDEX [IX_Facts_TypeID] ON [dbo].[Sales_Star_Facts] 
(
	[TypeID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO

/****** Object:  Index [IX_Facts_UOMPrimary]    Script Date: 08/13/2010 21:49:06 ******/
CREATE NONCLUSTERED INDEX [IX_Facts_UOMPrimary] ON [dbo].[Sales_Star_Facts] 
(
	[UnitOfMeasurePrimary] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO

/****** Object:  Index [IX_ORDERSuffix]    Script Date: 08/13/2010 21:49:06 ******/
CREATE NONCLUSTERED INDEX [IX_ORDERSuffix] ON [dbo].[Sales_Star_Facts] 
(
	[OrderSuffix] ASC,
	[OrderTypeCode] ASC
)
INCLUDE ( [SourceID],
[OrderNumber]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO

/****** Object:  Index [missing_index_10]    Script Date: 08/13/2010 21:49:06 ******/
CREATE NONCLUSTERED INDEX [missing_index_10] ON [dbo].[Sales_Star_Facts] 
(
	[BusinessUnitID] ASC,
	[ItemNumber02] ASC,
	[HeaderBusinessUnit] ASC,
	[OrderTypeCode] ASC,
	[LineType] ASC
)
INCLUDE ( [ItemNumberID],
[ItemNumber],
[GLDateID],
[QuantityShipped],
[ExtendedPrice],
[UnitOfMeasureAsInput]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO

/****** Object:  Index [missing_index_1009]    Script Date: 08/13/2010 21:49:06 ******/
CREATE NONCLUSTERED INDEX [missing_index_1009] ON [dbo].[Sales_Star_Facts] 
(
	[InvoiceDateID] ASC
)
INCLUDE ( [FactsExtID],
[CustomerNumberID],
[ItemNumberID],
[ShiptoNumber],
[ItemNumber],
[QuantityShipped],
[ExtendedPrice],
[ExtendedCost],
[UnitOfMeasureAsInput],
[UnitOfMeasurePrimary]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [missing_index_114]    Script Date: 08/13/2010 21:49:06 ******/
CREATE NONCLUSTERED INDEX [missing_index_114] ON [dbo].[Sales_Star_Facts] 
(
	[OrderNumber] ASC
)
INCLUDE ( [FactsExtID],
[ItemNumberID],
[LineNumber],
[BusinessUnitCode],
[ShiptoNumber],
[ItemNumber],
[ItemNumber02],
[InvoiceDateID],
[QuantityShipped],
[ExtendedPrice],
[UnitOfMeasureAsInput],
[ParentNumber]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO

/****** Object:  Index [missing_index_116]    Script Date: 08/13/2010 21:49:06 ******/
CREATE NONCLUSTERED INDEX [missing_index_116] ON [dbo].[Sales_Star_Facts] 
(
	[BusinessUnitID] ASC
)
INCLUDE ( [ItemNumberID],
[ItemNumber],
[GLDateID],
[ExtendedPrice],
[UnitOfMeasureAsInput]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO

/****** Object:  Index [missing_index_1216]    Script Date: 08/13/2010 21:49:06 ******/
CREATE NONCLUSTERED INDEX [missing_index_1216] ON [dbo].[Sales_Star_Facts] 
(
	[TransactionTypeID] ASC
)
INCLUDE ( [ItemNumberID],
[ItemNumber],
[GLDateID],
[QuantityShipped],
[ExtendedPrice],
[ExtendedCost],
[UnitOfMeasureAsInput]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [missing_index_1218]    Script Date: 08/13/2010 21:49:06 ******/
CREATE NONCLUSTERED INDEX [missing_index_1218] ON [dbo].[Sales_Star_Facts] 
(
	[TransactionTypeID] ASC
)
INCLUDE ( [ItemNumberID],
[ItemNumber],
[GLDateID],
[QuantityShipped],
[ExtendedPrice],
[ExtendedCost],
[UnitOfMeasureAsInput]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [missing_index_1226]    Script Date: 08/13/2010 21:49:06 ******/
CREATE NONCLUSTERED INDEX [missing_index_1226] ON [dbo].[Sales_Star_Facts] 
(
	[TransactionTypeID] ASC
)
INCLUDE ( [BusinessUnitID],
[ItemNumberID],
[ItemNumber],
[GLDateID],
[QuantityShipped],
[ExtendedPrice],
[ExtendedCost],
[UnitOfMeasureAsInput]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [missing_index_1254]    Script Date: 08/13/2010 21:49:06 ******/
CREATE NONCLUSTERED INDEX [missing_index_1254] ON [dbo].[Sales_Star_Facts] 
(
	[CustomerNumberID] ASC
)
INCLUDE ( [FactsExtID],
[SourceID],
[OrderNumberDocumentCompany],
[OrderNumber],
[OrderTypeCode],
[LineNumber],
[ItemNumber],
[TransactionDateID],
[InvoiceDateID],
[QuantityShipped],
[UnitOfMeasureAsInput],
[AmountOpen]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [missing_index_1278]    Script Date: 08/13/2010 21:49:06 ******/
CREATE NONCLUSTERED INDEX [missing_index_1278] ON [dbo].[Sales_Star_Facts] 
(
	[ShiptoNumber] ASC
)
INCLUDE ( [FactsExtID],
[CustomerNumberID],
[ItemNumberID],
[ItemNumber],
[InvoiceDateID],
[QuantityShipped],
[ExtendedPrice],
[ExtendedCost],
[UnitOfMeasureAsInput]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [missing_index_1287]    Script Date: 08/13/2010 21:49:06 ******/
CREATE NONCLUSTERED INDEX [missing_index_1287] ON [dbo].[Sales_Star_Facts] 
(
	[OrderTypeCode] ASC
)
INCLUDE ( [CustomerNumberID],
[ItemNumberID],
[ItemNumber],
[GLDateID],
[QuantityShipped],
[UnitOfMeasureAsInput]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [missing_index_1302]    Script Date: 08/13/2010 21:49:06 ******/
CREATE NONCLUSTERED INDEX [missing_index_1302] ON [dbo].[Sales_Star_Facts] 
(
	[ItemNumber02] ASC
)
INCLUDE ( [CustomerNumberID],
[ItemNumberID],
[ItemNumber],
[GLDateID],
[QuantityShipped],
[ExtendedPrice],
[UnitOfMeasureAsInput],
[UnitOfMeasurePrimary]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [missing_index_1329]    Script Date: 08/13/2010 21:49:06 ******/
CREATE NONCLUSTERED INDEX [missing_index_1329] ON [dbo].[Sales_Star_Facts] 
(
	[BusinessUnitID] ASC,
	[TransactionDateID] ASC
)
INCLUDE ( [FactsExtID]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [missing_index_1331]    Script Date: 08/13/2010 21:49:06 ******/
CREATE NONCLUSTERED INDEX [missing_index_1331] ON [dbo].[Sales_Star_Facts] 
(
	[BusinessUnitID] ASC,
	[TransactionDateID] ASC
)
INCLUDE ( [FactsExtID],
[OrderNumber]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [missing_index_137]    Script Date: 08/13/2010 21:49:06 ******/
CREATE NONCLUSTERED INDEX [missing_index_137] ON [dbo].[Sales_Star_Facts] 
(
	[OrderNumber] ASC,
	[OrderTypeCode] ASC
)
INCLUDE ( [FactsExtID],
[FactsHdrID],
[SourceID],
[OrderNumberDocumentCompany],
[LineNumber],
[OrderSuffix],
[TransactionType],
[BusinessUnitCode],
[AddressNumber],
[ItemNumber],
[RequestedDateID],
[ForecastType],
[YearCalendarYear]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO

/****** Object:  Index [missing_index_1411]    Script Date: 08/13/2010 21:49:06 ******/
CREATE NONCLUSTERED INDEX [missing_index_1411] ON [dbo].[Sales_Star_Facts] 
(
	[TransactionTypeID] ASC,
	[OrderTypeCode] ASC
)
INCLUDE ( [FactsExtID],
[ItemNumberID],
[OrderNumberDocumentCompany],
[OrderNumber],
[LineNumber],
[OrderSuffix],
[TransactionType],
[BusinessUnitCode],
[AddressNumber],
[ItemNumber],
[QuantityShipped],
[ExtendedPrice],
[UnitOfMeasureAsInput],
[ForecastType],
[YearCalendarYear]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [missing_index_1430]    Script Date: 08/13/2010 21:49:06 ******/
CREATE NONCLUSTERED INDEX [missing_index_1430] ON [dbo].[Sales_Star_Facts] 
(
	[CustomerNumberID] ASC
)
INCLUDE ( [ItemNumberID],
[ItemNumber],
[InvoiceDateID],
[QuantityShipped],
[ExtendedPrice],
[UnitOfMeasureAsInput]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO

/****** Object:  Index [missing_index_147]    Script Date: 08/13/2010 21:49:06 ******/
CREATE NONCLUSTERED INDEX [missing_index_147] ON [dbo].[Sales_Star_Facts] 
(
	[InvoiceDateID] ASC
)
INCLUDE ( [FactsExtID],
[CustomerNumberID],
[ItemNumberID],
[ItemNumber],
[GLDateID],
[QuantityShipped],
[ExtendedPrice],
[ExtendedCost],
[UnitOfMeasureAsInput]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO

/****** Object:  Index [missing_index_18]    Script Date: 08/13/2010 21:49:06 ******/
CREATE NONCLUSTERED INDEX [missing_index_18] ON [dbo].[Sales_Star_Facts] 
(
	[BusinessUnitID] ASC,
	[OrderTypeCode] ASC,
	[LineType] ASC,
	[HeaderBusinessUnit] ASC
)
INCLUDE ( [ItemNumberID],
[ItemNumber],
[ItemNumber02],
[QuantityShipped],
[UnitOfMeasureAsInput]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO

/****** Object:  Index [missing_index_20]    Script Date: 08/13/2010 21:49:06 ******/
CREATE NONCLUSTERED INDEX [missing_index_20] ON [dbo].[Sales_Star_Facts] 
(
	[BusinessUnitID] ASC,
	[OrderTypeCode] ASC,
	[LineType] ASC,
	[HeaderBusinessUnit] ASC
)
INCLUDE ( [ItemNumberID],
[ItemNumber],
[ItemNumber02],
[GLDateID],
[QuantityShipped],
[ExtendedPrice],
[UnitOfMeasureAsInput]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO

/****** Object:  Index [missing_index_24]    Script Date: 08/13/2010 21:49:06 ******/
CREATE NONCLUSTERED INDEX [missing_index_24] ON [dbo].[Sales_Star_Facts] 
(
	[BusinessUnitID] ASC,
	[OrderTypeCode] ASC,
	[LineType] ASC,
	[HeaderBusinessUnit] ASC
)
INCLUDE ( [ItemNumberID],
[ItemNumber],
[ItemNumber02],
[GLDateID],
[ExtendedPrice],
[UnitOfMeasureAsInput]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO

/****** Object:  Index [missing_index_251]    Script Date: 08/13/2010 21:49:06 ******/
CREATE NONCLUSTERED INDEX [missing_index_251] ON [dbo].[Sales_Star_Facts] 
(
	[UnitOfMeasureAsInput] ASC
)
INCLUDE ( [SourceID],
[ItemNumber]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO

/****** Object:  Index [missing_index_252]    Script Date: 08/13/2010 21:49:06 ******/
CREATE NONCLUSTERED INDEX [missing_index_252] ON [dbo].[Sales_Star_Facts] 
(
	[BusinessUnitID] ASC,
	[HeaderBusinessUnit] ASC
)
INCLUDE ( [FactsExtID],
[CustomerNumberID],
[ItemNumberID],
[ShiptoNumber],
[ItemNumber],
[ItemNumber02],
[TransactionDateID],
[QuantityShipped],
[UnitPrice],
[ExtendedPrice],
[UnitCost],
[ExtendedCost],
[UnitOfMeasureAsInput]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO

/****** Object:  Index [missing_index_254]    Script Date: 08/13/2010 21:49:06 ******/
CREATE NONCLUSTERED INDEX [missing_index_254] ON [dbo].[Sales_Star_Facts] 
(
	[ItemNumber02] ASC,
	[HeaderBusinessUnit] ASC
)
INCLUDE ( [FactsExtID],
[BusinessUnitID],
[CustomerNumberID],
[ItemNumberID],
[ShiptoNumber],
[ItemNumber],
[TransactionDateID],
[QuantityShipped],
[UnitPrice],
[ExtendedPrice],
[UnitCost],
[ExtendedCost],
[UnitOfMeasureAsInput]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO

/****** Object:  Index [missing_index_257]    Script Date: 08/13/2010 21:49:06 ******/
CREATE NONCLUSTERED INDEX [missing_index_257] ON [dbo].[Sales_Star_Facts] 
(
	[InvoiceDateID] ASC
)
INCLUDE ( [CustomerNumberID],
[ItemNumber],
[ExtendedPrice],
[UnitOfMeasureAsInput]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO

/****** Object:  Index [missing_index_262]    Script Date: 08/13/2010 21:49:06 ******/
CREATE NONCLUSTERED INDEX [missing_index_262] ON [dbo].[Sales_Star_Facts] 
(
	[GLDateID] ASC
)
INCLUDE ( [CustomerNumberID],
[ItemNumberID],
[ShiptoNumber],
[ItemNumber],
[ExtendedPrice],
[UnitOfMeasureAsInput]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO

/****** Object:  Index [missing_index_280]    Script Date: 08/13/2010 21:49:06 ******/
CREATE NONCLUSTERED INDEX [missing_index_280] ON [dbo].[Sales_Star_Facts] 
(
	[OrderTypeCode] ASC
)
INCLUDE ( [ItemNumberID],
[OrderNumber],
[LineNumber],
[ShiptoNumber],
[ItemNumber],
[GLDateID],
[QuantityShipped],
[ExtendedPrice],
[UnitOfMeasureAsInput]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO

/****** Object:  Index [missing_index_297]    Script Date: 08/13/2010 21:49:06 ******/
CREATE NONCLUSTERED INDEX [missing_index_297] ON [dbo].[Sales_Star_Facts] 
(
	[GLDateID] ASC
)
INCLUDE ( [FactsExtID],
[ExtendedPrice],
[ExtendedCost]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO

/****** Object:  Index [missing_index_301]    Script Date: 08/13/2010 21:49:06 ******/
CREATE NONCLUSTERED INDEX [missing_index_301] ON [dbo].[Sales_Star_Facts] 
(
	[BusinessUnitID] ASC,
	[ItemNumber02] ASC,
	[HeaderBusinessUnit] ASC,
	[OrderTypeCode] ASC,
	[LineType] ASC
)
INCLUDE ( [ItemNumberID],
[OrderNumber],
[ItemNumber],
[GLDateID],
[QuantityShipped],
[ExtendedPrice],
[UnitOfMeasureAsInput]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO

/****** Object:  Index [missing_index_306]    Script Date: 08/13/2010 21:49:06 ******/
CREATE NONCLUSTERED INDEX [missing_index_306] ON [dbo].[Sales_Star_Facts] 
(
	[BusinessUnitID] ASC,
	[HeaderBusinessUnit] ASC,
	[OrderTypeCode] ASC,
	[LineType] ASC
)
INCLUDE ( [ItemNumberID],
[ItemNumber],
[ItemNumber02],
[GLDateID],
[QuantityShipped],
[ExtendedPrice],
[UnitOfMeasureAsInput]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO

/****** Object:  Index [missing_index_308]    Script Date: 08/13/2010 21:49:06 ******/
CREATE NONCLUSTERED INDEX [missing_index_308] ON [dbo].[Sales_Star_Facts] 
(
	[BusinessUnitID] ASC,
	[HeaderBusinessUnit] ASC,
	[OrderTypeCode] ASC,
	[LineType] ASC
)
INCLUDE ( [ItemNumberID],
[OrderNumber],
[ItemNumber],
[ItemNumber02],
[GLDateID],
[QuantityShipped],
[ExtendedPrice],
[UnitOfMeasureAsInput]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO

/****** Object:  Index [missing_index_318]    Script Date: 08/13/2010 21:49:06 ******/
CREATE NONCLUSTERED INDEX [missing_index_318] ON [dbo].[Sales_Star_Facts] 
(
	[BusinessUnitID] ASC,
	[OrderTypeCode] ASC,
	[LineType] ASC,
	[HeaderBusinessUnit] ASC
)
INCLUDE ( [ItemNumberID],
[ItemNumber],
[GLDateID],
[QuantityShipped],
[ExtendedPrice],
[UnitOfMeasureAsInput]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO

/****** Object:  Index [missing_index_328]    Script Date: 08/13/2010 21:49:06 ******/
CREATE NONCLUSTERED INDEX [missing_index_328] ON [dbo].[Sales_Star_Facts] 
(
	[BusinessUnitID] ASC,
	[TransactionType] ASC
)
INCLUDE ( [CustomerNumberID],
[ItemNumberID],
[OrderNumber],
[LineNumber],
[ItemNumber],
[ItemNumber02],
[GLDateID],
[QuantityShipped],
[ExtendedPrice],
[UnitOfMeasureAsInput],
[HeaderBusinessUnit]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO

/****** Object:  Index [missing_index_399]    Script Date: 08/13/2010 21:49:06 ******/
CREATE NONCLUSTERED INDEX [missing_index_399] ON [dbo].[Sales_Star_Facts] 
(
	[ShiptoNumber] ASC
)
INCLUDE ( [FactsExtID],
[CustomerNumberID],
[OrderNumber],
[LineNumber],
[ItemNumber],
[GLDateID],
[QuantityShipped],
[ExtendedPrice],
[UnitOfMeasureAsInput]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO

/****** Object:  Index [missing_index_401]    Script Date: 08/13/2010 21:49:06 ******/
CREATE NONCLUSTERED INDEX [missing_index_401] ON [dbo].[Sales_Star_Facts] 
(
	[ShiptoNumber] ASC
)
INCLUDE ( [FactsHdrID],
[BusinessUnitID],
[CustomerNumberID],
[ItemNumberID],
[SourceID],
[OrderNumberDocumentCompany],
[OrderNumber],
[OrderTypeCode],
[LineNumber],
[ItemNumber],
[InvoiceDateID],
[UnitOfMeasureAsInput]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO

/****** Object:  Index [missing_index_415]    Script Date: 08/13/2010 21:49:06 ******/
CREATE NONCLUSTERED INDEX [missing_index_415] ON [dbo].[Sales_Star_Facts] 
(
	[OrderTypeCode] ASC,
	[HeaderBusinessUnit] ASC
)
INCLUDE ( [ItemNumber],
[GLDateID],
[ExtendedPrice],
[UnitOfMeasureAsInput]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO

/****** Object:  Index [missing_index_430]    Script Date: 08/13/2010 21:49:06 ******/
CREATE NONCLUSTERED INDEX [missing_index_430] ON [dbo].[Sales_Star_Facts] 
(
	[HeaderBusinessUnit] ASC,
	[OrderTypeCode] ASC
)
INCLUDE ( [ItemNumber],
[GLDateID],
[ExtendedPrice],
[UnitOfMeasureAsInput]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO

/****** Object:  Index [missing_index_433]    Script Date: 08/13/2010 21:49:06 ******/
CREATE NONCLUSTERED INDEX [missing_index_433] ON [dbo].[Sales_Star_Facts] 
(
	[GLDateID] ASC,
	[OrderTypeCode] ASC,
	[HeaderBusinessUnit] ASC
)
INCLUDE ( [ItemNumber],
[ExtendedPrice],
[UnitOfMeasureAsInput]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO

/****** Object:  Index [missing_index_435]    Script Date: 08/13/2010 21:49:06 ******/
CREATE NONCLUSTERED INDEX [missing_index_435] ON [dbo].[Sales_Star_Facts] 
(
	[ShiptoNumber] ASC
)
INCLUDE ( [FactsExtID],
[CustomerNumberID],
[OrderNumber],
[LineNumber],
[ItemNumber],
[GLDateID],
[QuantityShipped],
[ExtendedPrice],
[ExtendedCost],
[UnitOfMeasureAsInput]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO

/****** Object:  Index [missing_index_452]    Script Date: 08/13/2010 21:49:06 ******/
CREATE NONCLUSTERED INDEX [missing_index_452] ON [dbo].[Sales_Star_Facts] 
(
	[HeaderBusinessUnit] ASC,
	[OrderTypeCode] ASC
)
INCLUDE ( [LineType],
[ItemNumber],
[GLDateID],
[ExtendedPrice],
[UnitOfMeasureAsInput]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO

/****** Object:  Index [missing_index_454]    Script Date: 08/13/2010 21:49:06 ******/
CREATE NONCLUSTERED INDEX [missing_index_454] ON [dbo].[Sales_Star_Facts] 
(
	[OrderTypeCode] ASC,
	[LineType] ASC,
	[HeaderBusinessUnit] ASC
)
INCLUDE ( [ItemNumber],
[GLDateID],
[ExtendedPrice],
[UnitOfMeasureAsInput]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO

/****** Object:  Index [missing_index_459]    Script Date: 08/13/2010 21:49:06 ******/
CREATE NONCLUSTERED INDEX [missing_index_459] ON [dbo].[Sales_Star_Facts] 
(
	[GLDateID] ASC
)
INCLUDE ( [FactsExtID],
[ExtendedPrice],
[ExtendedCost]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO

/****** Object:  Index [missing_index_461]    Script Date: 08/13/2010 21:49:06 ******/
CREATE NONCLUSTERED INDEX [missing_index_461] ON [dbo].[Sales_Star_Facts] 
(
	[GLDateID] ASC
)
INCLUDE ( [FactsExtID]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO

/****** Object:  Index [missing_index_463]    Script Date: 08/13/2010 21:49:06 ******/
CREATE NONCLUSTERED INDEX [missing_index_463] ON [dbo].[Sales_Star_Facts] 
(
	[HeaderBusinessUnit] ASC,
	[OrderTypeCode] ASC
)
INCLUDE ( [ItemNumberID],
[ItemNumber],
[GLDateID],
[ExtendedPrice],
[UnitOfMeasureAsInput]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO

/****** Object:  Index [missing_index_465]    Script Date: 08/13/2010 21:49:06 ******/
CREATE NONCLUSTERED INDEX [missing_index_465] ON [dbo].[Sales_Star_Facts] 
(
	[OrderTypeCode] ASC,
	[HeaderBusinessUnit] ASC
)
INCLUDE ( [ItemNumberID],
[ItemNumber],
[GLDateID],
[ExtendedPrice],
[UnitOfMeasureAsInput]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO

/****** Object:  Index [missing_index_472]    Script Date: 08/13/2010 21:49:06 ******/
CREATE NONCLUSTERED INDEX [missing_index_472] ON [dbo].[Sales_Star_Facts] 
(
	[HeaderBusinessUnit] ASC,
	[OrderTypeCode] ASC
)
INCLUDE ( [FactsExtID],
[ItemNumber],
[GLDateID],
[ExtendedPrice],
[UnitOfMeasureAsInput]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO

/****** Object:  Index [missing_index_474]    Script Date: 08/13/2010 21:49:06 ******/
CREATE NONCLUSTERED INDEX [missing_index_474] ON [dbo].[Sales_Star_Facts] 
(
	[OrderTypeCode] ASC,
	[HeaderBusinessUnit] ASC
)
INCLUDE ( [FactsExtID],
[ItemNumber],
[GLDateID],
[ExtendedPrice],
[UnitOfMeasureAsInput]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO

/****** Object:  Index [missing_index_476]    Script Date: 08/13/2010 21:49:06 ******/
CREATE NONCLUSTERED INDEX [missing_index_476] ON [dbo].[Sales_Star_Facts] 
(
	[HeaderBusinessUnit] ASC,
	[OrderTypeCode] ASC
)
INCLUDE ( [FactsExtID],
[ItemNumberID],
[ItemNumber],
[GLDateID],
[ExtendedPrice],
[UnitOfMeasureAsInput]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO

/****** Object:  Index [missing_index_478]    Script Date: 08/13/2010 21:49:06 ******/
CREATE NONCLUSTERED INDEX [missing_index_478] ON [dbo].[Sales_Star_Facts] 
(
	[OrderTypeCode] ASC,
	[HeaderBusinessUnit] ASC
)
INCLUDE ( [FactsExtID],
[ItemNumberID],
[ItemNumber],
[GLDateID],
[ExtendedPrice],
[UnitOfMeasureAsInput]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO

/****** Object:  Index [missing_index_503]    Script Date: 08/13/2010 21:49:06 ******/
CREATE NONCLUSTERED INDEX [missing_index_503] ON [dbo].[Sales_Star_Facts] 
(
	[ItemNumber02] ASC
)
INCLUDE ( [FactsHdrID]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO

/****** Object:  Index [missing_index_530]    Script Date: 08/13/2010 21:49:06 ******/
CREATE NONCLUSTERED INDEX [missing_index_530] ON [dbo].[Sales_Star_Facts] 
(
	[ShiptoNumber] ASC,
	[OrderTypeCode] ASC
)
INCLUDE ( [ItemNumberID],
[OrderNumber],
[LineNumber],
[ItemNumber],
[GLDateID],
[QuantityShipped],
[ExtendedPrice],
[UnitOfMeasureAsInput]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO

/****** Object:  Index [missing_index_532]    Script Date: 08/13/2010 21:49:06 ******/
CREATE NONCLUSTERED INDEX [missing_index_532] ON [dbo].[Sales_Star_Facts] 
(
	[CustomerNumberID] ASC
)
INCLUDE ( [FactsHdrID],
[BusinessUnitID],
[ItemNumberID],
[SourceID],
[OrderNumberDocumentCompany],
[OrderNumber],
[OrderTypeCode],
[LineNumber],
[ShiptoNumber],
[ItemNumber],
[InvoiceDateID],
[UnitOfMeasureAsInput]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO

/****** Object:  Index [missing_index_554]    Script Date: 08/13/2010 21:49:06 ******/
CREATE NONCLUSTERED INDEX [missing_index_554] ON [dbo].[Sales_Star_Facts] 
(
	[ShiptoNumber] ASC
)
INCLUDE ( [ItemNumberID],
[OrderNumber],
[LineNumber],
[ItemNumber],
[GLDateID],
[QuantityShipped],
[ExtendedPrice],
[UnitOfMeasureAsInput]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO

/****** Object:  Index [missing_index_558]    Script Date: 08/13/2010 21:49:06 ******/
CREATE NONCLUSTERED INDEX [missing_index_558] ON [dbo].[Sales_Star_Facts] 
(
	[ShiptoNumber] ASC
)
INCLUDE ( [ItemNumberID],
[OrderNumber],
[OrderTypeCode],
[LineNumber],
[ItemNumber],
[GLDateID],
[QuantityShipped],
[ExtendedPrice],
[UnitOfMeasureAsInput]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO

/****** Object:  Index [missing_index_560]    Script Date: 08/13/2010 21:49:06 ******/
CREATE NONCLUSTERED INDEX [missing_index_560] ON [dbo].[Sales_Star_Facts] 
(
	[TransactionType] ASC,
	[OrderTypeCode] ASC
)
INCLUDE ( [ItemNumberID],
[OrderNumber],
[LineNumber],
[ShiptoNumber],
[ItemNumber],
[GLDateID],
[QuantityShipped],
[ExtendedPrice],
[UnitOfMeasureAsInput]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO

/****** Object:  Index [missing_index_610]    Script Date: 08/13/2010 21:49:06 ******/
CREATE NONCLUSTERED INDEX [missing_index_610] ON [dbo].[Sales_Star_Facts] 
(
	[BusinessUnitID] ASC
)
INCLUDE ( [OrderNumber],
[ItemNumber],
[InvoiceDateID],
[ExtendedPrice],
[ExtendedCost],
[UnitOfMeasureAsInput],
[HeaderBusinessUnit]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO

/****** Object:  Index [missing_index_616]    Script Date: 08/13/2010 21:49:06 ******/
CREATE NONCLUSTERED INDEX [missing_index_616] ON [dbo].[Sales_Star_Facts] 
(
	[ItemNumberID] ASC
)
INCLUDE ( [FactsHdrID],
[BusinessUnitID],
[CustomerNumberID],
[SourceID],
[OrderNumberDocumentCompany],
[OrderNumber],
[OrderTypeCode],
[LineNumber],
[ShiptoNumber],
[ItemNumber],
[InvoiceDateID],
[UnitOfMeasureAsInput]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO

/****** Object:  Index [missing_index_619]    Script Date: 08/13/2010 21:49:06 ******/
CREATE NONCLUSTERED INDEX [missing_index_619] ON [dbo].[Sales_Star_Facts] 
(
	[ShiptoNumber] ASC
)
INCLUDE ( [FactsExtID],
[CustomerNumberID],
[OrderNumber],
[OrderTypeCode],
[LineNumber],
[ItemNumber],
[GLDateID],
[QuantityShipped],
[ExtendedPrice],
[UnitOfMeasureAsInput]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO

/****** Object:  Index [missing_index_621]    Script Date: 08/13/2010 21:49:06 ******/
CREATE NONCLUSTERED INDEX [missing_index_621] ON [dbo].[Sales_Star_Facts] 
(
	[TransactionTypeID] ASC
)
INCLUDE ( [CustomerNumberID],
[ItemNumberID],
[OrderNumber],
[LineNumber],
[ShiptoNumber],
[ItemNumber],
[InvoiceDateID],
[QuantityShipped],
[ExtendedPrice],
[UnitOfMeasureAsInput]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO

/****** Object:  Index [missing_index_625]    Script Date: 08/13/2010 21:49:06 ******/
CREATE NONCLUSTERED INDEX [missing_index_625] ON [dbo].[Sales_Star_Facts] 
(
	[BusinessUnitID] ASC,
	[HeaderBusinessUnit] ASC
)
INCLUDE ( [OrderNumber],
[ItemNumber],
[InvoiceDateID],
[ExtendedPrice],
[ExtendedCost],
[UnitOfMeasureAsInput]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO

/****** Object:  Index [missing_index_645]    Script Date: 08/13/2010 21:49:06 ******/
CREATE NONCLUSTERED INDEX [missing_index_645] ON [dbo].[Sales_Star_Facts] 
(
	[CustomerNumberID] ASC
)
INCLUDE ( [ItemNumberID],
[OrderNumber],
[LineNumber],
[ShiptoNumber],
[ItemNumber],
[UnitOfMeasureAsInput]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO

/****** Object:  Index [missing_index_654]    Script Date: 08/13/2010 21:49:06 ******/
CREATE NONCLUSTERED INDEX [missing_index_654] ON [dbo].[Sales_Star_Facts] 
(
	[TransactionTypeID] ASC
)
INCLUDE ( [CustomerNumberID],
[OrderNumber],
[LineNumber],
[ShiptoNumber],
[ItemNumber],
[InvoiceDateID],
[QuantityShipped],
[ExtendedPrice],
[UnitOfMeasureAsInput]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO

/****** Object:  Index [missing_index_656]    Script Date: 08/13/2010 21:49:06 ******/
CREATE NONCLUSTERED INDEX [missing_index_656] ON [dbo].[Sales_Star_Facts] 
(
	[HeaderBusinessUnit] ASC
)
INCLUDE ( [FactsExtID],
[ItemNumberID],
[OrderNumber],
[LineNumber],
[ItemNumber],
[GLDateID],
[QuantityShipped],
[ExtendedPrice],
[ExtendedCost],
[UnitOfMeasureAsInput]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO

/****** Object:  Index [missing_index_77]    Script Date: 08/13/2010 21:49:06 ******/
CREATE NONCLUSTERED INDEX [missing_index_77] ON [dbo].[Sales_Star_Facts] 
(
	[InvoiceDateID] ASC
)
INCLUDE ( [FactsExtID],
[CustomerNumberID],
[ItemNumber],
[GLDateID],
[ExtendedPrice],
[ExtendedCost],
[UnitOfMeasureAsInput]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO

/****** Object:  Index [missing_index_9]    Script Date: 08/13/2010 21:49:06 ******/
CREATE NONCLUSTERED INDEX [missing_index_9] ON [dbo].[Sales_Star_Facts] 
(
	[GLDateID] ASC,
	[OrderTypeCode] ASC
)
INCLUDE ( [ItemNumberID],
[ItemNumber],
[QuantityShipped],
[ExtendedPrice],
[ExtendedCost],
[UnitOfMeasureAsInput]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO

/****** Object:  Index [missing_index_938]    Script Date: 08/13/2010 21:49:06 ******/
CREATE NONCLUSTERED INDEX [missing_index_938] ON [dbo].[Sales_Star_Facts] 
(
	[OrderTypeCode] ASC
)
INCLUDE ( [FactsExtID],
[ItemNumberID],
[OrderNumber],
[LineNumber],
[ShiptoNumber],
[ItemNumber],
[ItemNumber02],
[InvoiceDateID],
[GLDateID],
[QuantityShipped],
[OtherQuantity],
[ExtendedPrice],
[ExtendedCost],
[UnitOfMeasureAsInput]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO

/****** Object:  Index [missing_index_964]    Script Date: 08/13/2010 21:49:06 ******/
CREATE NONCLUSTERED INDEX [missing_index_964] ON [dbo].[Sales_Star_Facts] 
(
	[BusinessUnitID] ASC,
	[TransactionTypeID] ASC,
	[OrderNumber] ASC,
	[OrderTypeCode] ASC
)
INCLUDE ( [FactsExtID],
[ItemNumberID],
[OrderNumberDocumentCompany],
[LineNumber],
[OrderSuffix],
[TransactionType],
[BusinessUnitCode],
[AddressNumber],
[ItemNumber],
[ExtendedPrice],
[UnitOfMeasureAsInput],
[ForecastType],
[YearCalendarYear]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO

/****** Object:  Index [missing_index_987]    Script Date: 08/13/2010 21:49:06 ******/
CREATE NONCLUSTERED INDEX [missing_index_987] ON [dbo].[Sales_Star_Facts] 
(
	[AddressNumber] ASC,
	[GLDateID] ASC
)
INCLUDE ( [FactsExtID],
[FactsHdrID],
[BusinessUnitID],
[CompanyNumberID],
[CustomerNumberID],
[ItemNumberID],
[SalesRepID],
[TransactionTypeID],
[TypeID],
[CostID],
[PriceID],
[SourceID],
[Source],
[OrderNumberDocumentCompany],
[OrderNumber],
[OrderTypeCode],
[LineNumber],
[OrderSuffix],
[TransactionType],
[BusinessUnitCode],
[LineType],
[CompanyNumber],
[ShiptoNumber],
[ItemNumber],
[ItemNumber02],
[ItemNumber03],
[StatusCodeNext],
[StatusCodeLast],
[RequestedDateID],
[TransactionDateID],
[PromisedDeliveryDateID],
[OriginalPromisedDateID],
[ActualDeliveryDateID],
[InvoiceDateID],
[CancelDateID],
[PromisedDeliveryID],
[PriceEffectiveDateID],
[ShipDateID],
[FutureUseDateID],
[QuantityOrdered],
[QuantityBackordered],
[QuantityRelieved],
[QuantityShipped],
[QuantityShippedToDate],
[QuantityCanceled],
[QuantityOpen],
[PrimaryQuantityOrdered],
[SecondaryQuantityOrdered],
[OtherQuantity],
[UnitPrice],
[ExtendedPrice],
[UnitCost],
[ExtendedCost],
[UnitOfMeasureAsInput],
[UnitOfMeasurePrimary],
[UnitOfMeasureSecondary],
[SalespersonCode01],
[ParentNumber],
[HeaderBusinessUnit],
[CurrencyCode],
[AmountForecast],
[QuantityForecast],
[ForecastType],
[BypassForcingYN],
[RevisedFlag],
[DateUpdatedID],
[UserID],
[WorkStationID],
[ProgramID],
[YearCalendarYear],
[TimeOfDay],
[AmountOpen],
[SalesUpdatedDateID],
[InsertIndicator],
[InsertDate],
[ChangeIndicator],
[ChangeDate],
[DeleteIndicator],
[DeleteDate],
[PurgeDate]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [missing_index_989]    Script Date: 08/13/2010 21:49:06 ******/
CREATE NONCLUSTERED INDEX [missing_index_989] ON [dbo].[Sales_Star_Facts] 
(
	[TransactionTypeID] ASC,
	[OrderNumber] ASC,
	[GLDateID] ASC
)
INCLUDE ( [FactsExtID],
[FactsHdrID],
[BusinessUnitID],
[CompanyNumberID],
[CustomerNumberID],
[ItemNumberID],
[SalesRepID],
[TypeID],
[CostID],
[PriceID],
[SourceID],
[Source],
[OrderNumberDocumentCompany],
[OrderTypeCode],
[LineNumber],
[OrderSuffix],
[TransactionType],
[BusinessUnitCode],
[LineType],
[CompanyNumber],
[AddressNumber],
[ShiptoNumber],
[ItemNumber],
[ItemNumber02],
[ItemNumber03],
[StatusCodeNext],
[StatusCodeLast],
[RequestedDateID],
[TransactionDateID],
[PromisedDeliveryDateID],
[OriginalPromisedDateID],
[ActualDeliveryDateID],
[InvoiceDateID],
[CancelDateID],
[PromisedDeliveryID],
[PriceEffectiveDateID],
[ShipDateID],
[FutureUseDateID],
[QuantityOrdered],
[QuantityBackordered],
[QuantityRelieved],
[QuantityShipped],
[QuantityShippedToDate],
[QuantityCanceled],
[QuantityOpen],
[PrimaryQuantityOrdered],
[SecondaryQuantityOrdered],
[OtherQuantity],
[UnitPrice],
[ExtendedPrice],
[UnitCost],
[ExtendedCost],
[UnitOfMeasureAsInput],
[UnitOfMeasurePrimary],
[UnitOfMeasureSecondary],
[SalespersonCode01],
[ParentNumber],
[HeaderBusinessUnit],
[CurrencyCode],
[AmountForecast],
[QuantityForecast],
[ForecastType],
[BypassForcingYN],
[RevisedFlag],
[DateUpdatedID],
[UserID],
[WorkStationID],
[ProgramID],
[YearCalendarYear],
[TimeOfDay],
[AmountOpen],
[SalesUpdatedDateID],
[InsertIndicator],
[InsertDate],
[ChangeIndicator],
[ChangeDate],
[DeleteIndicator],
[DeleteDate],
[PurgeDate]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [missing_index_998]    Script Date: 08/13/2010 21:49:06 ******/
CREATE NONCLUSTERED INDEX [missing_index_998] ON [dbo].[Sales_Star_Facts] 
(
	[ShiptoNumber] ASC
)
INCLUDE ( [FactsExtID],
[CustomerNumberID],
[ItemNumberID],
[SourceID],
[OrderNumberDocumentCompany],
[OrderNumber],
[OrderTypeCode],
[LineNumber],
[ItemNumber],
[InvoiceDateID],
[QuantityShipped],
[ExtendedPrice],
[ExtendedCost],
[UnitOfMeasureAsInput],
[UnitOfMeasurePrimary]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [missing_index_YCHOI_24]    Script Date: 08/13/2010 21:49:06 ******/
CREATE NONCLUSTERED INDEX [missing_index_YCHOI_24] ON [dbo].[Sales_Star_Facts] 
(
	[SourceID] ASC,
	[OrderNumberDocumentCompany] ASC,
	[OrderNumber] ASC,
	[OrderTypeCode] ASC,
	[LineNumber] ASC
)
INCLUDE ( [FactsHdrID],
[BusinessUnitID],
[CustomerNumberID],
[ItemNumberID],
[ShiptoNumber],
[ItemNumber],
[InvoiceDateID],
[UnitOfMeasureAsInput]) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO

/****** Object:  Index [OrderType]    Script Date: 08/13/2010 21:49:06 ******/
CREATE NONCLUSTERED INDEX [OrderType] ON [dbo].[Sales_Star_Facts] 
(
	[OrderTypeCode] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
GO


